package com.wlh.mapper;

import com.wlh.common.PageVo;
import com.wlh.entity.ProjectMessage;
import com.wlh.entity.Student;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author Mr.Wei
 * @since 2023-12-22
 */
public interface ProjectMessageMapper extends BaseMapper<ProjectMessage> {

	@Select("SELECT * FROM project_message WHERE project_no LIKE CONCAT(#{projectNo}, '%')")
	public IPage<ProjectMessage> search(Page<ProjectMessage> vo, String projectNo);

	@Select("select * from project_message where project_no = #{projectNo} and status = #{status}")
	public List<ProjectMessage> searchByProjectNo(String projectNo, String status);

}
